<?php
namespace Application\Model;
use Zend\Db\Adapter\Adapter;
use \Exception;
Class User{
    protected  $_adapter;
    public function __construct(Adapter $adapter) {
        $this->_adapter = $adapter;
    }
    public function getUserByLogin($username,$password) {
        try {
            $stmt = $this->_adapter->createStatement();
            $sql= "Call sp_login(:p_username,:p_password)";
            $stmt->prepare($sql);
            $result = $stmt->execute($sql);
        } catch (Exception $exc) {
            echo $exc->getTraceAsString();
        }
        }
}